import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;


public class ASINItems {
private long item_no;
private String ASIN;
public long getItem_no() {
	return item_no;
}
public void setItem_no(long item_no) {
	this.item_no = item_no;
}
public String getASIN() {
	return ASIN;
}
public void setASIN(String aSIN) {
	ASIN = aSIN;
}

public static int insert(Connection connection,String asin, long item_no ) throws SQLException{
	PreparedStatement ps = connection
			.prepareStatement("insert into ASINItems(item_no,ASIN) values (?,?)");
	ps.setString(2, asin);
	ps.setLong(1,item_no);
		int rs=  ps.executeUpdate();
	connection.commit();
	
  return rs;
	
}
}
